﻿CREATE TABLE [dbo].[MilitaryRanks]
(
[OID] [bigint] NOT NULL IDENTITY(1, 1),
[Version] [timestamp] NOT NULL,
[BranchOfServiceID] [bigint] NOT NULL,
[RankStructure] [varchar] (30) NOT NULL,
[Rank] [varchar] (50) NOT NULL,
[PayGrade] [varchar] (5) NOT NULL,
[Abbreviation] [varchar] (10) NOT NULL,
[Active] [tinyint] NOT NULL,
[DisplayOrder] [smallint] NOT NULL,
[CreatedDate] [datetime] NOT NULL
) ON [PRIMARY]


